UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iRg1z5iETf1u3uUhxxmPG4+JsrELOffI5FySPDUO9wg='
WHERE
key_id = '38a0aceef2b4b5d37107cc555e2adbcd46ba379953e482f46c5671febea99644'
AND (
token = 'iRg1z5iETf1u3uUhxxmPG4+JsrELOffI5FySPDUO9wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)