UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0slFvdiu3BoujMN0sdF3nBaowCWJgII93HRal6OyKxU='
WHERE
key_id = '381878e828a26e2881490c21f019dee97c61afd1a7cda069373f899e49af44b5'
AND (
token = '0slFvdiu3BoujMN0sdF3nBaowCWJgII93HRal6OyKxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)