UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KYCgDauWCXN/1zUVtqYmey+wszLyAAwv28XFFVT7ME='
WHERE
key_id = '7d14b07beabd5a12c2be8507df39b4da0ce7a5eb9c9d80899e861aebffc50dfc'
AND (
token = '/KYCgDauWCXN/1zUVtqYmey+wszLyAAwv28XFFVT7ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)