UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHjQxhFEc1GB2LozdUVBgK7fYktXzt5WVrG+JI54EHw='
WHERE
key_id = '126caf5b49e4e8878bb1103679bfde8ecd4fcc82a4387ad73f0940e932bc5008'
AND (
token = 'BHjQxhFEc1GB2LozdUVBgK7fYktXzt5WVrG+JI54EHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)