UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I7kobcy0+16tQXvyEDNck/hEVcY7YcYwErJtMPtnNYg='
WHERE
key_id = '1816d8f97b7a00c921e6fe95ecb66693528ae464e9bdccb91bdcd285ab5d3a54'
AND (
token = 'I7kobcy0+16tQXvyEDNck/hEVcY7YcYwErJtMPtnNYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)