UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJlfLHZ7lOhlUC4XnYAAiPC3DYsd6UjwdImxMRaOv2A='
WHERE
key_id = '1789909e8f36ef050f451ba17cd2901ba0fa09ed5d43d86d61da2ecdc3f9aaaa'
AND (
token = 'DJlfLHZ7lOhlUC4XnYAAiPC3DYsd6UjwdImxMRaOv2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)