UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2QqS01tJiyBG1WcMy2Q0FFAzHfVmbctX7K7g+aJaEAE='
WHERE
key_id = '52b474321b63ed396fd50b2a7fdd699c9e323369a64225ef45366e2244bf97f1'
AND (
token = '2QqS01tJiyBG1WcMy2Q0FFAzHfVmbctX7K7g+aJaEAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)