UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3QGrIqKJPEPvnMBVT/k87JUcyVi6VeafNUUvOkYXK7g='
WHERE
key_id = 'aa0fd68584ee07525c0035a69bd6de4756413e7aaf102507da5c78dea9dc9a31'
AND (
token = '3QGrIqKJPEPvnMBVT/k87JUcyVi6VeafNUUvOkYXK7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)