UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9aQQZbcIc8IxX2kUN/kgFX+JhiWyCIE1BU1VL0xSzcM='
WHERE
key_id = '277306934843091a3f75f2fc1449ee481c22d3d0fe3f5312b83a30dd0a2faf1f'
AND (
token = '9aQQZbcIc8IxX2kUN/kgFX+JhiWyCIE1BU1VL0xSzcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)