UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JU7vvm0IZbMGqvSrZtWYB1tiPpCSl3D1wMj33uApcQA='
WHERE
key_id = '1646313cc8fe4aa65de54e5d6587c105d14183604e90233d219c75535e4181df'
AND (
token = 'JU7vvm0IZbMGqvSrZtWYB1tiPpCSl3D1wMj33uApcQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)