UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XT6X5P8pia2c8jSyKcCm5ueQdo9xFwY8z0i9ezot55w='
WHERE
key_id = 'fa4a064e941bd23083771354d67340e756af04824dfe038c45071dfd8d2877c3'
AND (
token = 'XT6X5P8pia2c8jSyKcCm5ueQdo9xFwY8z0i9ezot55w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)