UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UiB5aSBqzCPr+ER6nhB6FNAX2a0nlRSY0hkmm8Ivzg4='
WHERE
key_id = 'e6156379c39003c27a76df23007d3fb86e8be4caabdc950ebd0288cca161fa80'
AND (
token = 'UiB5aSBqzCPr+ER6nhB6FNAX2a0nlRSY0hkmm8Ivzg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)