UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PgGt2jy2Lqc52l2TT1YCT40yjPyC720Mgu6SswprtUA='
WHERE
key_id = '34c3ffaa3093f59d514763ff4c2f4551c3a0f3dc96f30392de6bcd9a6ff1b476'
AND (
token = 'PgGt2jy2Lqc52l2TT1YCT40yjPyC720Mgu6SswprtUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)