UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E7Mxay+hr03FS9aQQKhX8lZgGN3NcXz8hd2UTztvyTc='
WHERE
key_id = 'd7c177390c0b7226e2d4464fe5f80955e39d7a89263e35f6482f6cdc70283064'
AND (
token = 'E7Mxay+hr03FS9aQQKhX8lZgGN3NcXz8hd2UTztvyTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)