UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iw1ki0dgNHuwlX2d4o+5z+2LaUEYC7RCX1bd8TGPjFI='
WHERE
key_id = 'bb7c9fe653f50bdbf9568a2857f1bd9b024fdbbf9e63dad00fb959fad0a82dfe'
AND (
token = 'iw1ki0dgNHuwlX2d4o+5z+2LaUEYC7RCX1bd8TGPjFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)