UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PW9QbUZZoGQ5H4VaHp0AdVC1ue3AgJXT7Xks612G1sw='
WHERE
key_id = 'f38ba296b43f363ea09cde891af8a111f425848dc32751068a6c72681afd4c0f'
AND (
token = 'PW9QbUZZoGQ5H4VaHp0AdVC1ue3AgJXT7Xks612G1sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)