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