UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jYC608ZoYkJIj3zLdtajWdiqWKhjtJdRWYbDG9A54M0='
WHERE
key_id = '47b6e9c290f2432e3b45306566a664d2f0b02e18e339ac947b9cec4a6fb316bd'
AND (
token = 'jYC608ZoYkJIj3zLdtajWdiqWKhjtJdRWYbDG9A54M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)