UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLHinbYeWbBamJGgFOtoYsDLuMVT5nVQ3iH6iSY2POc='
WHERE
key_id = '0d946538fd76777ee894b4556959a500944597a4b08df8d28d79be1ea7488e2b'
AND (
token = 'pLHinbYeWbBamJGgFOtoYsDLuMVT5nVQ3iH6iSY2POc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)