UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dv06/UhHvF4fq7CP0iK2MuK7gZZEsocSgw0iIAVqrKQ='
WHERE
key_id = 'cc370e98bb07e38542de49be12e1e981160ac7785d3e540651b549004513782b'
AND (
token = 'dv06/UhHvF4fq7CP0iK2MuK7gZZEsocSgw0iIAVqrKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)