UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uPJPnqF665LvBLXxhx3Yj4670hxpfXZnM7AypLQdFxM='
WHERE
key_id = '7eb9ef651cd055f411ae8b92295843634407626d68f4197d82820b7acfe12676'
AND (
token = 'uPJPnqF665LvBLXxhx3Yj4670hxpfXZnM7AypLQdFxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)