UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WSpnfSfCJLuuzo00lPB+26jM/6V5Fro717TRnhW4h8I='
WHERE
key_id = '84a0ced24945df3d728a54f7503f234de258572d386478e776901d61a75a4cfe'
AND (
token = 'WSpnfSfCJLuuzo00lPB+26jM/6V5Fro717TRnhW4h8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)