UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NzB9t/Sq8gaYZ01XgfJ05FzWe09Nxwv43hr9tM7xowU='
WHERE
key_id = '0dce05820c04af49c03a87ad029abd19ea574a31c63ac822a8c3bb626debed89'
AND (
token = 'NzB9t/Sq8gaYZ01XgfJ05FzWe09Nxwv43hr9tM7xowU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)