UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJEzeOpKWCNkd3DGOAEfHl0PetYNNXuy55M99Yv9uL8='
WHERE
key_id = '586272a642a368deddc4cf932c8b218e366078a7e781a2cecaa6127e3b9c3eee'
AND (
token = 'zJEzeOpKWCNkd3DGOAEfHl0PetYNNXuy55M99Yv9uL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)