UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kNzBlUXZTLD7otE2Mvn2Gumo6MYykuZcZxm30DcZyxM='
WHERE
key_id = '67bd88077abaf5883a71c0ce1133a34a93918233c630397018dc402236ad80f6'
AND (
token = 'kNzBlUXZTLD7otE2Mvn2Gumo6MYykuZcZxm30DcZyxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)