UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3djNRUnFu53IhUBauQWSPJOc2TexDrPI87RM2FgVFrk='
WHERE
key_id = '9905efcfb527ad7fb8416e0b52a2cceb877f439698d3b2098c4d5651f7331ba1'
AND (
token = '3djNRUnFu53IhUBauQWSPJOc2TexDrPI87RM2FgVFrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)