UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K1I0ZaZj1ZR7g6PIdN4xwI7kt/VQwOG1KrQc3zcngU0='
WHERE
key_id = 'c16a8ceb70582a7710ffc9b839fc244f6a63721adff3d6e1a60dde867834b3cb'
AND (
token = 'K1I0ZaZj1ZR7g6PIdN4xwI7kt/VQwOG1KrQc3zcngU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)