UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Cr0W74hq2sLWPi7/zphuUrM0f9TuBcExSbHIP3VSAA='
WHERE
key_id = 'eb7d420f728475ec6685737679703c24b7a95a62f720800380fdad6f896139cc'
AND (
token = '7Cr0W74hq2sLWPi7/zphuUrM0f9TuBcExSbHIP3VSAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)