UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UTxC/67Vo/zfHtSbUSFNGE8si41r8dvPZYbPARQId18='
WHERE
key_id = 'b1bc640696450ff4d5ff0345e3372bd745cf7070dc750284aeb091682fe4e20b'
AND (
token = 'UTxC/67Vo/zfHtSbUSFNGE8si41r8dvPZYbPARQId18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)